[dbo].[BAEEventGetAutoEnrollFunctions]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEEventGetAutoEnrollFunctions

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@eventCode	varchar(10)	10

SQL Script

create procedure [dbo].[BAEEventGetAutoEnrollFunctions] @eventCode varchar(10) as
SELECT * FROM
    Product p
    INNER JOIN  Product_Function pf on p.PRODUCT_CODE = pf.PRODUCT_CODE
     WHERE p.PRODUCT_MAJOR = @eventCode AND AUTO_ENROLL = '1'
    AND pf.WEB_ENABLED = '1'
    ORDER BY TITLE_KEY

GO

Uses

[dbo].[Product]
[dbo].[Product_Function]
dbo